Featured
-
No Featured Found!
Tags
How to show CREATE TABLE syntax in MySQL?
Sometimes we need to check the CREATE TABLE syntax for already created table in the database. When we need to check what kind of columns and what datatype a column has in a table then we require the CREATE TABLE syntax for that table.
Syntax
...
How to show the create table statement of a table in MySQL
To display the create table statement of a table in MySQL you need to execute the following command:
use dbname;
show create table tablename;
But to view this statement you must have the privilege to access the table.
